/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package sv.com.intesal.rrhh.sql;

/**
 *
 * @author ejerez
 */
public class SQLCargo {

    public static final String insert = "INSERT INTO CARGO(codigo_a,nombre_c,estado_c)VALUES(?,?,?)";
    public static final String update = "UPDATE CARGO SET codigo_c=?,nombre_c=?,estado_c=? WHERE codigo_c=?";
    public static final String getCargos = "SELECT a.codigo_a,a.nombre_a,c.codigo_c,c.nombre_c,c.estado_c FROM CARGO as c,AREA as a where a.codigo_a=c.codigo_a order by a.nombre_a,c.nombre_c";
    public static final String getCargoActivas = "SELECT a.codigo_a,a.nombre_a,c.codigo_c,c.nombre_c,c.estado_c FROM CARGO as c,AREA as a where a.codigo_a=c.codigo_a and c.estado_c='A' order by a.nombre_a,c.nombre_c";
    public static final String getCargoActivas_x_Area = "SELECT a.codigo_a,a.nombre_a,c.codigo_c,c.nombre_c,c.estado_c FROM CARGO as c,AREA as a where a.codigo_a=c.codigo_a and c.estado_c='A' and c.codigo_a=? order by a.nombre_a,c.nombre_c";
}
